/*
 Navicat Premium Data Transfer

 Source Server         : 本地数据库
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost
 Source Database       : travel_user

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : utf-8

 Date: 08/27/2018 23:30:35 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '编号',
  `mobile` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '手机',
  `email` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '邮箱',
  `user_type` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT '1' COMMENT '1.默认普通用户,2.超级用户,3.超级管理员',
  `password` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '密码',
  `name` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '姓名',
  `photo` varchar(1000) COLLATE utf8_bin DEFAULT NULL COMMENT '用户头像',
  `login_ip` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '最后登陆IP',
  `login_date` datetime DEFAULT NULL COMMENT '最后登陆时间',
  `login_flag` varchar(64) COLLATE utf8_bin DEFAULT '1' COMMENT '0.不可登录,1.默认可登录,2.锁住',
  `create_by` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '创建者',
  `create_date` datetime NOT NULL COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '更新者',
  `update_date` datetime NOT NULL COMMENT '更新时间',
  `remarks` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注信息',
  `url` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '可访问的URL',
  `del_flag` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '0.未注销,1.注销',
  PRIMARY KEY (`id`),
  KEY `sys_user_update_date` (`update_date`),
  KEY `sys_user_del_flag` (`del_flag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='用户表';

-- ----------------------------
--  Records of `sys_user`
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('2303256dad6e4405817c6ae23590e3c9', '13185631558', null, '1', '44cb5fa65e17a8f105912516d44f58481b2c170b27951602', '13185631558', null, '0:0:0:0:0:0:0:1', '2018-08-27 22:22:14', '1', '13185631558', '2018-08-25 11:08:10', '13185631558', '2018-08-27 22:22:14', null, null, '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
